package com.cloudlead.commonData.query;

import static com.mysema.query.types.PathMetadataFactory.*;
import com.cloudlead.commonData.entity.ETbCustomerOrder;


import com.mysema.query.types.path.*;

import com.mysema.query.types.PathMetadata;
import javax.annotation.Generated;
import com.mysema.query.types.Path;

import com.mysema.query.sql.ColumnMetadata;
import java.sql.Types;

import com.mysema.query.sql.*;

import com.cloudlead.common.lang.annotation.Label;


/**
 * QTbCustomerOrder is a Querydsl query type for ETbCustomerOrder
 */
@Label("TbCustomerOrder查询")
@Generated("com.cloudlead.utils.persistence.codegen.serializer.SimpleMetaDataSerializer")
public class QTbCustomerOrder extends RelationalPathBase<ETbCustomerOrder> {

    private static final long serialVersionUID = 79094393;

    public static final QTbCustomerOrder tbCustomerOrder = new QTbCustomerOrder("tb_customer_order");

    public class PrimaryKeys {

        public final PrimaryKey<ETbCustomerOrder> primary = createPrimaryKey(id);

    }

    public class ForeignKeys {

        public final ForeignKey<com.cloudlead.commonData.entity.EBaseShipRoutePrice> shipRoutePriceFK = createForeignKey(forwarderPriceId, "id");

        public final ForeignKey<com.cloudlead.commonData.entity.EBaseVoyage> baseVoyage1 = createForeignKey(baseVoyage, "id");

        public final ForeignKey<com.cloudlead.commonData.entity.EBaseCompany> belongForward = createForeignKey(belongForwarder, "id");

        public final ForeignKey<com.cloudlead.commonData.entity.ETbPlacePrice> delCarPriceFk = createForeignKey(delCarPriceId, "id");

        public final ForeignKey<com.cloudlead.commonData.entity.EBaseCompany> desShipOwnerFk = createForeignKey(destCompanyId, "id");

        public final ForeignKey<com.cloudlead.commonData.entity.ETbPlacePrice> polCarPriceFk = createForeignKey(polCarPriceId, "id");

        public final ForeignKey<com.cloudlead.commonData.entity.EBaseCompany> tbCustomerOrderBaseCompany1Fk = createForeignKey(baseCompanyId, "id");

        public final ForeignKey<com.cloudlead.commonData.entity.ERegion> sDoor1 = createForeignKey(sDoor, "id");

        public final ForeignKey<com.cloudlead.commonData.entity.ERegion> fDoor1 = createForeignKey(fDoor, "id");

        public final ForeignKey<com.cloudlead.commonData.entity.ETbContainerInfo> _customerFk = createInvForeignKey(id, "tb_customer_order_id");

        public final ForeignKey<com.cloudlead.commonData.entity.ETbFleetOrder> _tbFleetOrderTbCustomerOrder1Fk = createInvForeignKey(id, "tb_customer_order_id");

        public final ForeignKey<com.cloudlead.commonData.entity.ETbBookingSpaceOrder> _tbBookingSpaceOrderTbCustomerOrder1Fk = createInvForeignKey(id, "tb_customer_order_id");

        public final ForeignKey<com.cloudlead.commonData.entity.ETbOrderstatus> _orderStatusCustomerId = createInvForeignKey(id, "customerOrderID");

    }

    public final StringPath baseCompanyId = createString("baseCompanyId");

    public final StringPath baseVoyage = createString("baseVoyage");

    public final StringPath belongCompany = createString("belongCompany");

    public final StringPath belongForwarder = createString("belongForwarder");

    public final StringPath bussinessCode = createString("bussinessCode");

    public final StringPath comments = createString("comments");

    public final StringPath commodity = createString("commodity");

    public final StringPath consignee = createString("consignee");

    public final StringPath consigneeName = createString("consigneeName");

    public final StringPath delCarPriceId = createString("delCarPriceId");

    public final StringPath delName = createString("delName");

    public final StringPath delOrderState = createString("delOrderState");

    public final StringPath destCompanyId = createString("destCompanyId");

    public final StringPath fDoor = createString("fDoor");

    public final StringPath flag = createString("flag");

    public final StringPath forwarderPriceId = createString("forwarderPriceId");

    public final DateTimePath<org.joda.time.DateTime> fTime = createDateTime("fTime", org.joda.time.DateTime.class);

    public final StringPath id = createString("id");

    public final StringPath insuranceAgent = createString("insuranceAgent");

    public final DateTimePath<org.joda.time.DateTime> ordertime = createDateTime("ordertime", org.joda.time.DateTime.class);

    public final StringPath orderUser = createString("orderUser");

    public final StringPath polCarPriceId = createString("polCarPriceId");

    public final StringPath polName = createString("polName");

    public final StringPath polOrderState = createString("polOrderState");

    public final StringPath project = createString("project");

    public final StringPath quantity = createString("quantity");

    public final StringPath refrigeratingTemperature = createString("refrigeratingTemperature");

    public final StringPath sDoor = createString("sDoor");

    public final StringPath shipper = createString("shipper");

    public final StringPath shipperName = createString("shipperName");

    public final DateTimePath<org.joda.time.DateTime> sTime = createDateTime("sTime", org.joda.time.DateTime.class);

    public final NumberPath<Double> totalForwarderPrice = createNumber("totalForwarderPrice", Double.class);

    public final NumberPath<Double> totalPrice = createNumber("totalPrice", Double.class);

    public final StringPath ventilation = createString("ventilation");

    public final PrimaryKeys pk = new PrimaryKeys();

    public final ForeignKeys fk = new ForeignKeys();

    public QTbCustomerOrder(String variable) {
        super(ETbCustomerOrder.class, forVariable(variable), "null", "tb_customer_order");
        addMetadata();
    }

    public QTbCustomerOrder(String variable, String schema, String table) {
        super(ETbCustomerOrder.class, forVariable(variable), schema, table);
        addMetadata();
    }

    public QTbCustomerOrder(Path<? extends ETbCustomerOrder> path) {
        super(path.getType(), path.getMetadata(), "null", "tb_customer_order");
        addMetadata();
    }

    public QTbCustomerOrder(PathMetadata<?> metadata) {
        super(ETbCustomerOrder.class, metadata, "null", "tb_customer_order");
        addMetadata();
    }

    public void addMetadata() {
        addMetadata(baseCompanyId, ColumnMetadata.named("base_company_id").withIndex(20).ofType(Types.CHAR).withSize(24));
        addMetadata(baseVoyage, ColumnMetadata.named("baseVoyage").withIndex(23).ofType(Types.CHAR).withSize(24));
        addMetadata(belongCompany, ColumnMetadata.named("belongCompany").withIndex(27).ofType(Types.VARCHAR).withSize(500));
        addMetadata(belongForwarder, ColumnMetadata.named("belongForwarder").withIndex(34).ofType(Types.CHAR).withSize(24));
        addMetadata(bussinessCode, ColumnMetadata.named("bussinessCode").withIndex(13).ofType(Types.VARCHAR).withSize(45));
        addMetadata(comments, ColumnMetadata.named("comments").withIndex(15).ofType(Types.VARCHAR).withSize(2000));
        addMetadata(commodity, ColumnMetadata.named("commodity").withIndex(2).ofType(Types.VARCHAR).withSize(45));
        addMetadata(consignee, ColumnMetadata.named("consignee").withIndex(9).ofType(Types.VARCHAR).withSize(45));
        addMetadata(consigneeName, ColumnMetadata.named("consigneeName").withIndex(10).ofType(Types.VARCHAR).withSize(45));
        addMetadata(delCarPriceId, ColumnMetadata.named("delCarPriceId").withIndex(32).ofType(Types.CHAR).withSize(255));
        addMetadata(delName, ColumnMetadata.named("del_name").withIndex(25).ofType(Types.VARCHAR).withSize(255));
        addMetadata(delOrderState, ColumnMetadata.named("del_orderState").withIndex(29).ofType(Types.VARCHAR).withSize(100));
        addMetadata(destCompanyId, ColumnMetadata.named("dest_company_id").withIndex(26).ofType(Types.CHAR).withSize(24));
        addMetadata(fDoor, ColumnMetadata.named("fDoor").withIndex(17).ofType(Types.CHAR).withSize(24));
        addMetadata(flag, ColumnMetadata.named("flag").withIndex(21).ofType(Types.VARCHAR).withSize(8));
        addMetadata(forwarderPriceId, ColumnMetadata.named("forwarderPriceId").withIndex(30).ofType(Types.CHAR).withSize(255));
        addMetadata(fTime, ColumnMetadata.named("fTime").withIndex(18).ofType(Types.TIMESTAMP).withSize(19));
        addMetadata(id, ColumnMetadata.named("id").withIndex(1).ofType(Types.CHAR).withSize(24).notNull());
        addMetadata(insuranceAgent, ColumnMetadata.named("insuranceAgent").withIndex(6).ofType(Types.VARCHAR).withSize(45));
        addMetadata(ordertime, ColumnMetadata.named("ordertime").withIndex(14).ofType(Types.TIMESTAMP).withSize(19));
        addMetadata(orderUser, ColumnMetadata.named("orderUser").withIndex(22).ofType(Types.CHAR).withSize(24));
        addMetadata(polCarPriceId, ColumnMetadata.named("polCarPriceId").withIndex(31).ofType(Types.CHAR).withSize(255));
        addMetadata(polName, ColumnMetadata.named("pol_name").withIndex(24).ofType(Types.VARCHAR).withSize(255));
        addMetadata(polOrderState, ColumnMetadata.named("pol_orderState").withIndex(28).ofType(Types.VARCHAR).withSize(100));
        addMetadata(project, ColumnMetadata.named("project").withIndex(3).ofType(Types.VARCHAR).withSize(45));
        addMetadata(quantity, ColumnMetadata.named("quantity").withIndex(11).ofType(Types.VARCHAR).withSize(50));
        addMetadata(refrigeratingTemperature, ColumnMetadata.named("refrigeratingTemperature").withIndex(5).ofType(Types.VARCHAR).withSize(45));
        addMetadata(sDoor, ColumnMetadata.named("sDoor").withIndex(16).ofType(Types.CHAR).withSize(24));
        addMetadata(shipper, ColumnMetadata.named("shipper").withIndex(7).ofType(Types.VARCHAR).withSize(45));
        addMetadata(shipperName, ColumnMetadata.named("shipperName").withIndex(8).ofType(Types.VARCHAR).withSize(45));
        addMetadata(sTime, ColumnMetadata.named("sTime").withIndex(19).ofType(Types.TIMESTAMP).withSize(19));
        addMetadata(totalForwarderPrice, ColumnMetadata.named("totalForwarderPrice").withIndex(33).ofType(Types.DOUBLE).withSize(22));
        addMetadata(totalPrice, ColumnMetadata.named("totalPrice").withIndex(12).ofType(Types.DOUBLE).withSize(22));
        addMetadata(ventilation, ColumnMetadata.named("ventilation").withIndex(4).ofType(Types.VARCHAR).withSize(45));
    }

}

